{ "cells": [ { "cell_type": "markdown", "id": "daily-impression", "metadata": {}, "source": [ "# Load some data" ] }, { "cell_type": "code", "execution_count": 1, "id": "transparent-diversity", "metadata": {}, "outputs": [], "source": [ "import hotstepper as hs\n", "import pandas as pd\n", "import numpy as np\n", "import matplotlib.pyplot as plt" ] }, { "cell_type": "code", "execution_count": 2, "id": "biblical-gates", "metadata": {}, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Row ID Order ID Order Date Ship Date Ship Mode Customer ID \\\n", "0 1 CA-2016-152156 2016-11-08 2016-11-11 Second Class CG-12520 \n", "1 2 CA-2016-152156 2016-11-08 2016-11-11 Second Class CG-12520 \n", "2 3 CA-2016-138688 2016-06-12 2016-06-16 Second Class DV-13045 \n", "3 4 US-2015-108966 2015-10-11 2015-10-18 Standard Class SO-20335 \n", "4 5 US-2015-108966 2015-10-11 2015-10-18 Standard Class SO-20335 \n", "\n", " Customer Name Segment Country City ... \\\n", "0 Claire Gute Consumer United States Henderson ... \n", "1 Claire Gute Consumer United States Henderson ... \n", "2 Darrin Van Huff Corporate United States Los Angeles ... \n", "3 Sean O'Donnell Consumer United States Fort Lauderdale ... \n", "4 Sean O'Donnell Consumer United States Fort Lauderdale ... \n", "\n", " Postal Code Region Product ID Category Sub-Category \\\n", "0 42420 South FUR-BO-10001798 Furniture Bookcases \n", "1 42420 South FUR-CH-10000454 Furniture Chairs \n", "2 90036 West OFF-LA-10000240 Office Supplies Labels \n", "3 33311 South FUR-TA-10000577 Furniture Tables \n", "4 33311 South OFF-ST-10000760 Office Supplies Storage \n", "\n", " Product Name Sales Quantity \\\n", "0 Bush Somerset Collection Bookcase 261.9600 2 \n", "1 Hon Deluxe Fabric Upholstered Stacking Chairs,... 731.9400 3 \n", "2 Self-Adhesive Address Labels for Typewriters b... 14.6200 2 \n", "3 Bretford CR4500 Series Slim Rectangular Table 957.5775 5 \n", "4 Eldon Fold 'N Roll Cart System 22.3680 2 \n", "\n", " Discount Profit \n", "0 0.00 41.9136 \n", "1 0.00 219.5820 \n", "2 0.00 6.8714 \n", "3 0.45 -383.0310 \n", "4 0.20 2.5164 \n", "\n", "[5 rows x 21 columns]" ], "text/html": "
| \n | Row ID | \nOrder ID | \nOrder Date | \nShip Date | \nShip Mode | \nCustomer ID | \nCustomer Name | \nSegment | \nCountry | \nCity | \n... | \nPostal Code | \nRegion | \nProduct ID | \nCategory | \nSub-Category | \nProduct Name | \nSales | \nQuantity | \nDiscount | \nProfit | \n
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n1 | \nCA-2016-152156 | \n2016-11-08 | \n2016-11-11 | \nSecond Class | \nCG-12520 | \nClaire Gute | \nConsumer | \nUnited States | \nHenderson | \n... | \n42420 | \nSouth | \nFUR-BO-10001798 | \nFurniture | \nBookcases | \nBush Somerset Collection Bookcase | \n261.9600 | \n2 | \n0.00 | \n41.9136 | \n
| 1 | \n2 | \nCA-2016-152156 | \n2016-11-08 | \n2016-11-11 | \nSecond Class | \nCG-12520 | \nClaire Gute | \nConsumer | \nUnited States | \nHenderson | \n... | \n42420 | \nSouth | \nFUR-CH-10000454 | \nFurniture | \nChairs | \nHon Deluxe Fabric Upholstered Stacking Chairs,... | \n731.9400 | \n3 | \n0.00 | \n219.5820 | \n
| 2 | \n3 | \nCA-2016-138688 | \n2016-06-12 | \n2016-06-16 | \nSecond Class | \nDV-13045 | \nDarrin Van Huff | \nCorporate | \nUnited States | \nLos Angeles | \n... | \n90036 | \nWest | \nOFF-LA-10000240 | \nOffice Supplies | \nLabels | \nSelf-Adhesive Address Labels for Typewriters b... | \n14.6200 | \n2 | \n0.00 | \n6.8714 | \n
| 3 | \n4 | \nUS-2015-108966 | \n2015-10-11 | \n2015-10-18 | \nStandard Class | \nSO-20335 | \nSean O'Donnell | \nConsumer | \nUnited States | \nFort Lauderdale | \n... | \n33311 | \nSouth | \nFUR-TA-10000577 | \nFurniture | \nTables | \nBretford CR4500 Series Slim Rectangular Table | \n957.5775 | \n5 | \n0.45 | \n-383.0310 | \n
| 4 | \n5 | \nUS-2015-108966 | \n2015-10-11 | \n2015-10-18 | \nStandard Class | \nSO-20335 | \nSean O'Donnell | \nConsumer | \nUnited States | \nFort Lauderdale | \n... | \n33311 | \nSouth | \nOFF-ST-10000760 | \nOffice Supplies | \nStorage | \nEldon Fold 'N Roll Cart System | \n22.3680 | \n2 | \n0.20 | \n2.5164 | \n
5 rows × 21 columns
\n| \n | Metric | \nValue | \n
|---|---|---|
| 0 | \nCount | \n1434 | \n
| 1 | \nMean | \n761.85 | \n
| 2 | \nMedian | \n513.1 | \n
| 3 | \nMode | \n-6927.35 | \n
| 4 | \nStd | \n1363.45 | \n
| 5 | \nVar | \n1859001.89 | \n
| 6 | \nMin | \n-6927.35 | \n
| 7 | \n25% | \n140.24 | \n
| 8 | \n75% | \n1195.82 | \n
| 9 | \nMax | \n11642.96 | \n
| 10 | \nArea | \n26750137.57 | \n
| 11 | \nStart | \n2014-01-03 00:00:00 | \n
| 12 | \nEnd | \n2018-01-05 00:00:00 | \n